<!DOCTYPE HTML>
<html lang="en" >
    
    <head>
        
        <meta charset="UTF-8">
        <meta http-equiv="X-UA-Compatible" content="IE=edge" />
        <title>简单的登录注册 | MXY 1.0版Python整理</title>
        <meta content="text/html; charset=utf-8" http-equiv="Content-Type">
        <meta name="description" content="">
        <meta name="generator" content="GitBook 2.6.7">
        
        
        <meta name="HandheldFriendly" content="true"/>
        <meta name="viewport" content="width=device-width, initial-scale=1, user-scalable=no">
        <meta name="apple-mobile-web-app-capable" content="yes">
        <meta name="apple-mobile-web-app-status-bar-style" content="black">
        <link rel="apple-touch-icon-precomposed" sizes="152x152" href="../../gitbook/images/apple-touch-icon-precomposed-152.png">
        <link rel="shortcut icon" href="../../gitbook/images/favicon.ico" type="image/x-icon">
        
    <link rel="stylesheet" href="../../gitbook/style.css">
    
        
        <link rel="stylesheet" href="../../gitbook/plugins/gitbook-plugin-highlight/website.css">
        
    
        
        <link rel="stylesheet" href="../../gitbook/plugins/gitbook-plugin-search/search.css">
        
    
        
        <link rel="stylesheet" href="../../gitbook/plugins/gitbook-plugin-fontsettings/website.css">
        
    
    

        
    
    
    <link rel="next" href="../../home/12.Python实战项目/5.双色球.html" />
    
    
    <link rel="prev" href="../../home/12.Python实战项目/3.银行项目.html" />
    

        
    </head>
    <body>
        
        
    <div class="book"
        data-level="12.4"
        data-chapter-title="简单的登录注册"
        data-filepath="home/12.Python实战项目/4.简单的登录注册.md"
        data-basepath="../.."
        data-revision="Mon Oct 22 2018 08:32:35 GMT+0800 (中国标准时间)"
        data-innerlanguage="">
    

<div class="book-summary">
    <nav role="navigation">
        <ul class="summary">
            
            
            
            

            

            
    
        <li class="chapter " data-level="0" data-path="index.html">
            
                
                    <a href="../../index.html">
                
                        <i class="fa fa-check"></i>
                        
                        MXY整理版Python基础
                    </a>
            
            
        </li>
    
        <li class="chapter " data-level="1" >
            
            <span><b>1.</b> Python的安装和简介</span>
            
            
            <ul class="articles">
                
    
        <li class="chapter " data-level="1.1" data-path="home/1.Python的安装和简介/1.python基础知识.html">
            
                
                    <a href="../../home/1.Python的安装和简介/1.python基础知识.html">
                
                        <i class="fa fa-check"></i>
                        
                            <b>1.1.</b>
                        
                        Python的基础知识
                    </a>
            
            
        </li>
    
        <li class="chapter " data-level="1.2" data-path="home/1.Python的安装和简介/2.python的安装及版本检测.html">
            
                
                    <a href="../../home/1.Python的安装和简介/2.python的安装及版本检测.html">
                
                        <i class="fa fa-check"></i>
                        
                            <b>1.2.</b>
                        
                        Python安装及版本检测
                    </a>
            
            
        </li>
    
        <li class="chapter " data-level="1.3" data-path="home/1.Python的安装和简介/3.第一个python程序.html">
            
                
                    <a href="../../home/1.Python的安装和简介/3.第一个python程序.html">
                
                        <i class="fa fa-check"></i>
                        
                            <b>1.3.</b>
                        
                        第一个Python程序
                    </a>
            
            
        </li>
    

            </ul>
            
        </li>
    
        <li class="chapter " data-level="2" >
            
            <span><b>2.</b> Python的基本语法</span>
            
            
            <ul class="articles">
                
    
        <li class="chapter " data-level="2.1" data-path="home/2.Python的基本语法/1.注释及语句分类.html">
            
                
                    <a href="../../home/2.Python的基本语法/1.注释及语句分类.html">
                
                        <i class="fa fa-check"></i>
                        
                            <b>2.1.</b>
                        
                        注释及语句分类
                    </a>
            
            
        </li>
    
        <li class="chapter " data-level="2.2" data-path="home/2.Python的基本语法/2.命名方式和关键字.html">
            
                
                    <a href="../../home/2.Python的基本语法/2.命名方式和关键字.html">
                
                        <i class="fa fa-check"></i>
                        
                            <b>2.2.</b>
                        
                        命名方式和关键字
                    </a>
            
            
        </li>
    

            </ul>
            
        </li>
    
        <li class="chapter " data-level="3" >
            
            <span><b>3.</b> Python的变量及数据类型</span>
            
            
            <ul class="articles">
                
    
        <li class="chapter " data-level="3.1" data-path="home/3.变量和数据类型/1.变量.html">
            
                
                    <a href="../../home/3.变量和数据类型/1.变量.html">
                
                        <i class="fa fa-check"></i>
                        
                            <b>3.1.</b>
                        
                        变量
                    </a>
            
            
        </li>
    
        <li class="chapter " data-level="3.2" data-path="home/3.变量和数据类型/2.数据类型.html">
            
                
                    <a href="../../home/3.变量和数据类型/2.数据类型.html">
                
                        <i class="fa fa-check"></i>
                        
                            <b>3.2.</b>
                        
                        数据类型
                    </a>
            
            
        </li>
    
        <li class="chapter " data-level="3.3" data-path="home/3.变量和数据类型/3.数据类型转换.html">
            
                
                    <a href="../../home/3.变量和数据类型/3.数据类型转换.html">
                
                        <i class="fa fa-check"></i>
                        
                            <b>3.3.</b>
                        
                        数据类型转换
                    </a>
            
            
        </li>
    
        <li class="chapter " data-level="3.4" data-path="home/3.变量和数据类型/4.运算和运算符.html">
            
                
                    <a href="../../home/3.变量和数据类型/4.运算和运算符.html">
                
                        <i class="fa fa-check"></i>
                        
                            <b>3.4.</b>
                        
                        数据类型转换
                    </a>
            
            
        </li>
    

            </ul>
            
        </li>
    
        <li class="chapter " data-level="4" >
            
            <span><b>4.</b> Python的流程控制</span>
            
            
            <ul class="articles">
                
    
        <li class="chapter " data-level="4.1" data-path="home/4.流程控制/1.顺序结构和分支结构.html">
            
                
                    <a href="../../home/4.流程控制/1.顺序结构和分支结构.html">
                
                        <i class="fa fa-check"></i>
                        
                            <b>4.1.</b>
                        
                        顺序结构和分支结构
                    </a>
            
            
        </li>
    
        <li class="chapter " data-level="4.2" data-path="home/4.流程控制/2.循环结构.html">
            
                
                    <a href="../../home/4.流程控制/2.循环结构.html">
                
                        <i class="fa fa-check"></i>
                        
                            <b>4.2.</b>
                        
                        循环结构
                    </a>
            
            
        </li>
    

            </ul>
            
        </li>
    
        <li class="chapter " data-level="5" >
            
            <span><b>5.</b> 函数及作用域</span>
            
            
            <ul class="articles">
                
    
        <li class="chapter " data-level="5.1" data-path="home/5.函数及作用域/1.函数.html">
            
                
                    <a href="../../home/5.函数及作用域/1.函数.html">
                
                        <i class="fa fa-check"></i>
                        
                            <b>5.1.</b>
                        
                        函数
                    </a>
            
            
        </li>
    
        <li class="chapter " data-level="5.2" data-path="home/5.函数及作用域/2.函数文档.html">
            
                
                    <a href="../../home/5.函数及作用域/2.函数文档.html">
                
                        <i class="fa fa-check"></i>
                        
                            <b>5.2.</b>
                        
                        函数文档
                    </a>
            
            
        </li>
    
        <li class="chapter " data-level="5.3" data-path="home/5.函数及作用域/3.变量的作用域.html">
            
                
                    <a href="../../home/5.函数及作用域/3.变量的作用域.html">
                
                        <i class="fa fa-check"></i>
                        
                            <b>5.3.</b>
                        
                        变量的作用域
                    </a>
            
            
        </li>
    
        <li class="chapter " data-level="5.4" data-path="home/5.函数及作用域/4.内部函数和闭包操作.html">
            
                
                    <a href="../../home/5.函数及作用域/4.内部函数和闭包操作.html">
                
                        <i class="fa fa-check"></i>
                        
                            <b>5.4.</b>
                        
                        内部函数和闭包操作
                    </a>
            
            
        </li>
    
        <li class="chapter " data-level="5.5" data-path="home/5.函数及作用域/5.lambda表达式.html">
            
                
                    <a href="../../home/5.函数及作用域/5.lambda表达式.html">
                
                        <i class="fa fa-check"></i>
                        
                            <b>5.5.</b>
                        
                        lambda表达式
                    </a>
            
            
        </li>
    
        <li class="chapter " data-level="5.6" data-path="home/5.函数及作用域/6.高阶函数.html">
            
                
                    <a href="../../home/5.函数及作用域/6.高阶函数.html">
                
                        <i class="fa fa-check"></i>
                        
                            <b>5.6.</b>
                        
                        高阶函数
                    </a>
            
            
        </li>
    

            </ul>
            
        </li>
    
        <li class="chapter " data-level="6" >
            
            <span><b>6.</b> 内置函数及操作</span>
            
            
            <ul class="articles">
                
    
        <li class="chapter " data-level="6.1" data-path="home/6.内置函数及操作/1.字符串相关.html">
            
                
                    <a href="../../home/6.内置函数及操作/1.字符串相关.html">
                
                        <i class="fa fa-check"></i>
                        
                            <b>6.1.</b>
                        
                        字符串相关
                    </a>
            
            
        </li>
    
        <li class="chapter " data-level="6.2" data-path="home/6.内置函数及操作/2.format格式字符串.html">
            
                
                    <a href="../../home/6.内置函数及操作/2.format格式字符串.html">
                
                        <i class="fa fa-check"></i>
                        
                            <b>6.2.</b>
                        
                        format格式字符串
                    </a>
            
            
        </li>
    
        <li class="chapter " data-level="6.3" data-path="home/6.内置函数及操作/3.内建函数.html">
            
                
                    <a href="../../home/6.内置函数及操作/3.内建函数.html">
                
                        <i class="fa fa-check"></i>
                        
                            <b>6.3.</b>
                        
                        内建函数
                    </a>
            
            
        </li>
    
        <li class="chapter " data-level="6.4" data-path="home/6.内置函数及操作/4.列表.html">
            
                
                    <a href="../../home/6.内置函数及操作/4.列表.html">
                
                        <i class="fa fa-check"></i>
                        
                            <b>6.4.</b>
                        
                        列表
                    </a>
            
            
        </li>
    
        <li class="chapter " data-level="6.5" data-path="home/6.内置函数及操作/5.元组.html">
            
                
                    <a href="../../home/6.内置函数及操作/5.元组.html">
                
                        <i class="fa fa-check"></i>
                        
                            <b>6.5.</b>
                        
                        元组
                    </a>
            
            
        </li>
    
        <li class="chapter " data-level="6.6" data-path="home/6.内置函数及操作/6.字典.html">
            
                
                    <a href="../../home/6.内置函数及操作/6.字典.html">
                
                        <i class="fa fa-check"></i>
                        
                            <b>6.6.</b>
                        
                        字典
                    </a>
            
            
        </li>
    
        <li class="chapter " data-level="6.7" data-path="home/6.内置函数及操作/7.集合.html">
            
                
                    <a href="../../home/6.内置函数及操作/7.集合.html">
                
                        <i class="fa fa-check"></i>
                        
                            <b>6.7.</b>
                        
                        集合
                    </a>
            
            
        </li>
    
        <li class="chapter " data-level="6.8" data-path="home/6.内置函数及操作/8.文件操作.html">
            
                
                    <a href="../../home/6.内置函数及操作/8.文件操作.html">
                
                        <i class="fa fa-check"></i>
                        
                            <b>6.8.</b>
                        
                        文件操作
                    </a>
            
            
        </li>
    

            </ul>
            
        </li>
    
        <li class="chapter " data-level="7" >
            
            <span><b>7.</b> 常用的模块</span>
            
            
            <ul class="articles">
                
    
        <li class="chapter " data-level="7.1" data-path="home/7.常用模块/1.String模块.html">
            
                
                    <a href="../../home/7.常用模块/1.String模块.html">
                
                        <i class="fa fa-check"></i>
                        
                            <b>7.1.</b>
                        
                        String模块
                    </a>
            
            
        </li>
    
        <li class="chapter " data-level="7.2" data-path="home/7.常用模块/2.math模块.html">
            
                
                    <a href="../../home/7.常用模块/2.math模块.html">
                
                        <i class="fa fa-check"></i>
                        
                            <b>7.2.</b>
                        
                        math模块
                    </a>
            
            
        </li>
    
        <li class="chapter " data-level="7.3" data-path="home/7.常用模块/3.OS模块.html">
            
                
                    <a href="../../home/7.常用模块/3.OS模块.html">
                
                        <i class="fa fa-check"></i>
                        
                            <b>7.3.</b>
                        
                        OS模块
                    </a>
            
            
        </li>
    
        <li class="chapter " data-level="7.4" data-path="home/7.常用模块/4.zipfile模块.html">
            
                
                    <a href="../../home/7.常用模块/4.zipfile模块.html">
                
                        <i class="fa fa-check"></i>
                        
                            <b>7.4.</b>
                        
                        zipfile模块
                    </a>
            
            
        </li>
    
        <li class="chapter " data-level="7.5" data-path="home/7.常用模块/5.tarfile模块.html">
            
                
                    <a href="../../home/7.常用模块/5.tarfile模块.html">
                
                        <i class="fa fa-check"></i>
                        
                            <b>7.5.</b>
                        
                        tarfile模块
                    </a>
            
            
        </li>
    
        <li class="chapter " data-level="7.6" data-path="home/7.常用模块/6.shutil模块.html">
            
                
                    <a href="../../home/7.常用模块/6.shutil模块.html">
                
                        <i class="fa fa-check"></i>
                        
                            <b>7.6.</b>
                        
                        shutil模块
                    </a>
            
            
        </li>
    
        <li class="chapter " data-level="7.7" data-path="home/7.常用模块/7.时间相关模块.html">
            
                
                    <a href="../../home/7.常用模块/7.时间相关模块.html">
                
                        <i class="fa fa-check"></i>
                        
                            <b>7.7.</b>
                        
                        时间相关模块
                    </a>
            
            
        </li>
    

            </ul>
            
        </li>
    
        <li class="chapter " data-level="8" >
            
            <span><b>8.</b> 面向对象</span>
            
            
            <ul class="articles">
                
    
        <li class="chapter " data-level="8.1" data-path="home/8.面向对象/1.类和对象-上.html">
            
                
                    <a href="../../home/8.面向对象/1.类和对象-上.html">
                
                        <i class="fa fa-check"></i>
                        
                            <b>8.1.</b>
                        
                        类和对象-上
                    </a>
            
            
        </li>
    
        <li class="chapter " data-level="8.2" data-path="home/8.面向对象/2.类和对象-下.html">
            
                
                    <a href="../../home/8.面向对象/2.类和对象-下.html">
                
                        <i class="fa fa-check"></i>
                        
                            <b>8.2.</b>
                        
                        类和对象-下
                    </a>
            
            
        </li>
    
        <li class="chapter " data-level="8.3" data-path="home/8.面向对象/3.魔术方法.html">
            
                
                    <a href="../../home/8.面向对象/3.魔术方法.html">
                
                        <i class="fa fa-check"></i>
                        
                            <b>8.3.</b>
                        
                        魔术方法
                    </a>
            
            
        </li>
    
        <li class="chapter " data-level="8.4" data-path="home/8.面向对象/4.装饰器.html">
            
                
                    <a href="../../home/8.面向对象/4.装饰器.html">
                
                        <i class="fa fa-check"></i>
                        
                            <b>8.4.</b>
                        
                        装饰器
                    </a>
            
            
        </li>
    
        <li class="chapter " data-level="8.5" data-path="home/8.面向对象/5.抽象类.html">
            
                
                    <a href="../../home/8.面向对象/5.抽象类.html">
                
                        <i class="fa fa-check"></i>
                        
                            <b>8.5.</b>
                        
                        抽象类
                    </a>
            
            
        </li>
    
        <li class="chapter " data-level="8.6" data-path="home/8.面向对象/6.错误和异常处理.html">
            
                
                    <a href="../../home/8.面向对象/6.错误和异常处理.html">
                
                        <i class="fa fa-check"></i>
                        
                            <b>8.6.</b>
                        
                        错误和异常处理
                    </a>
            
            
        </li>
    
        <li class="chapter " data-level="8.7" data-path="home/8.面向对象/7.模块和包.html">
            
                
                    <a href="../../home/8.面向对象/7.模块和包.html">
                
                        <i class="fa fa-check"></i>
                        
                            <b>8.7.</b>
                        
                        模块和包
                    </a>
            
            
        </li>
    

            </ul>
            
        </li>
    
        <li class="chapter " data-level="9" >
            
            <span><b>9.</b> tkinter模块</span>
            
            
            <ul class="articles">
                
    
        <li class="chapter " data-level="9.1" data-path="home/9.tkinter模块/tkinter模块.html">
            
                
                    <a href="../../home/9.tkinter模块/tkinter模块.html">
                
                        <i class="fa fa-check"></i>
                        
                            <b>9.1.</b>
                        
                        tkinter模块
                    </a>
            
            
        </li>
    

            </ul>
            
        </li>
    
        <li class="chapter " data-level="10" data-path="home/10.网络编程/1.网络编程.html">
            
                
                    <a href="../../home/10.网络编程/1.网络编程.html">
                
                        <i class="fa fa-check"></i>
                        
                            <b>10.</b>
                        
                        网络编程
                    </a>
            
            
            <ul class="articles">
                
    
        <li class="chapter " data-level="10.1" data-path="home/10.网络编程/2.TCP编程.html">
            
                
                    <a href="../../home/10.网络编程/2.TCP编程.html">
                
                        <i class="fa fa-check"></i>
                        
                            <b>10.1.</b>
                        
                        TCP编程
                    </a>
            
            
        </li>
    
        <li class="chapter " data-level="10.2" data-path="home/10.网络编程/3.UDP编程.html">
            
                
                    <a href="../../home/10.网络编程/3.UDP编程.html">
                
                        <i class="fa fa-check"></i>
                        
                            <b>10.2.</b>
                        
                        UDP编程
                    </a>
            
            
        </li>
    

            </ul>
            
        </li>
    
        <li class="chapter " data-level="11" data-path="home/11.多任务/多任务原理.html">
            
                
                    <a href="../../home/11.多任务/多任务原理.html">
                
                        <i class="fa fa-check"></i>
                        
                            <b>11.</b>
                        
                        多任务
                    </a>
            
            
            <ul class="articles">
                
    
        <li class="chapter " data-level="11.1" data-path="home/11.多任务/1.多进程实现多任务.html">
            
                
                    <a href="../../home/11.多任务/1.多进程实现多任务.html">
                
                        <i class="fa fa-check"></i>
                        
                            <b>11.1.</b>
                        
                        多进程实现多任务
                    </a>
            
            
        </li>
    
        <li class="chapter " data-level="11.2" data-path="home/11.多任务/2.多线程实现多任务.html">
            
                
                    <a href="../../home/11.多任务/2.多线程实现多任务.html">
                
                        <i class="fa fa-check"></i>
                        
                            <b>11.2.</b>
                        
                        多线程实现多任务
                    </a>
            
            
        </li>
    
        <li class="chapter " data-level="11.3" data-path="home/11.多任务/3.协程实现多任务.html">
            
                
                    <a href="../../home/11.多任务/3.协程实现多任务.html">
                
                        <i class="fa fa-check"></i>
                        
                            <b>11.3.</b>
                        
                        协程实现多任务
                    </a>
            
            
        </li>
    

            </ul>
            
        </li>
    
        <li class="chapter " data-level="12" >
            
            <span><b>12.</b> Python实战项目</span>
            
            
            <ul class="articles">
                
    
        <li class="chapter " data-level="12.1" data-path="home/12.Python实战项目/1.简易计算器.html">
            
                
                    <a href="../../home/12.Python实战项目/1.简易计算器.html">
                
                        <i class="fa fa-check"></i>
                        
                            <b>12.1.</b>
                        
                        简易计算器
                    </a>
            
            
        </li>
    
        <li class="chapter " data-level="12.2" data-path="home/12.Python实战项目/2.自动售货机.html">
            
                
                    <a href="../../home/12.Python实战项目/2.自动售货机.html">
                
                        <i class="fa fa-check"></i>
                        
                            <b>12.2.</b>
                        
                        自动售货机
                    </a>
            
            
        </li>
    
        <li class="chapter " data-level="12.3" data-path="home/12.Python实战项目/3.银行项目.html">
            
                
                    <a href="../../home/12.Python实战项目/3.银行项目.html">
                
                        <i class="fa fa-check"></i>
                        
                            <b>12.3.</b>
                        
                        银行项目
                    </a>
            
            
        </li>
    
        <li class="chapter active" data-level="12.4" data-path="home/12.Python实战项目/4.简单的登录注册.html">
            
                
                    <a href="../../home/12.Python实战项目/4.简单的登录注册.html">
                
                        <i class="fa fa-check"></i>
                        
                            <b>12.4.</b>
                        
                        简单的登录注册
                    </a>
            
            
        </li>
    
        <li class="chapter " data-level="12.5" data-path="home/12.Python实战项目/5.双色球.html">
            
                
                    <a href="../../home/12.Python实战项目/5.双色球.html">
                
                        <i class="fa fa-check"></i>
                        
                            <b>12.5.</b>
                        
                        双色球
                    </a>
            
            
        </li>
    
        <li class="chapter " data-level="12.6" data-path="home/12.Python实战项目/6.python垃圾回收机制.html">
            
                
                    <a href="../../home/12.Python实战项目/6.python垃圾回收机制.html">
                
                        <i class="fa fa-check"></i>
                        
                            <b>12.6.</b>
                        
                        python垃圾回收机制
                    </a>
            
            
        </li>
    
        <li class="chapter " data-level="12.7" data-path="home/12.Python实战项目/7.turtle画国旗.html">
            
                
                    <a href="../../home/12.Python实战项目/7.turtle画国旗.html">
                
                        <i class="fa fa-check"></i>
                        
                            <b>12.7.</b>
                        
                        turtle画国旗
                    </a>
            
            
        </li>
    
        <li class="chapter " data-level="12.8" data-path="home/12.Python实战项目/8.turtle画小猪佩奇.html">
            
                
                    <a href="../../home/12.Python实战项目/8.turtle画小猪佩奇.html">
                
                        <i class="fa fa-check"></i>
                        
                            <b>12.8.</b>
                        
                        turtle画小猪佩奇
                    </a>
            
            
        </li>
    
        <li class="chapter " data-level="12.9" data-path="home/12.Python实战项目/9.turtle画个表.html">
            
                
                    <a href="../../home/12.Python实战项目/9.turtle画个表.html">
                
                        <i class="fa fa-check"></i>
                        
                            <b>12.9.</b>
                        
                        turtle画个表
                    </a>
            
            
        </li>
    

            </ul>
            
        </li>
    


            
            <li class="divider"></li>
            <li>
                <a href="https://www.gitbook.com" target="blank" class="gitbook-link">
                    Published with GitBook
                </a>
            </li>
            
        </ul>
    </nav>
</div>

    <div class="book-body">
        <div class="body-inner">
            <div class="book-header" role="navigation">
    <!-- Actions Left -->
    

    <!-- Title -->
    <h1>
        <i class="fa fa-circle-o-notch fa-spin"></i>
        <a href="../../" >MXY 1.0版Python整理</a>
    </h1>
</div>

            <div class="page-wrapper" tabindex="-1" role="main">
                <div class="page-inner">
                
                
                    <section class="normal" id="section-">
                    
                        <ul>
<li><h3 id="&#x6CE8;&#x518C;">&#x6CE8;&#x518C;</h3>
</li>
</ul>
<pre><code class="lang-py"><span class="hljs-comment"># coding:utf-8</span>

<span class="hljs-keyword">import</span> pymysql

<span class="hljs-comment"># &#x8FDE;&#x63A5;&#x6570;&#x636E;&#x5E93;</span>
connect = pymysql.connect(
    host = <span class="hljs-string">&quot;localhost&quot;</span>,
    user = <span class="hljs-string">&quot;root&quot;</span>,
    password = <span class="hljs-string">&quot;123456&quot;</span>,
    port = <span class="hljs-number">3306</span>,
    db=<span class="hljs-string">&quot;xdl&quot;</span>,
    charset = <span class="hljs-string">&quot;utf8&quot;</span>,
        )
<span class="hljs-comment"># &#x5B9E;&#x4F8B;&#x5316;&#x6E38;&#x6807;</span>
cur = connect.cursor()
<span class="hljs-keyword">while</span> <span class="hljs-keyword">True</span>:
    user_name = input(<span class="hljs-string">&quot;&#x8BF7;&#x8F93;&#x5165;&#x60A8;&#x7684;&#x7528;&#x6237;&#x540D;&#xFF1A;&quot;</span>)
    sql = <span class="hljs-string">&quot;select * from user&quot;</span>
    cur.execute(sql)
    results = cur.fetchall()
    <span class="hljs-keyword">for</span> row <span class="hljs-keyword">in</span> results:
        name = row[<span class="hljs-number">0</span>]
        <span class="hljs-keyword">if</span> user_name == name:
            print(<span class="hljs-string">&quot;&#x8BE5;&#x7528;&#x6237;&#x540D;&#x5DF2;&#x88AB;&#x6CE8;&#x518C;&#xFF0C;&#x8BF7;&#x91CD;&#x65B0;&#x8F93;&#x5165;&#xFF01;&quot;</span>)
            <span class="hljs-keyword">break</span>
    <span class="hljs-keyword">else</span>:
        <span class="hljs-keyword">while</span> <span class="hljs-keyword">True</span>:
            user_pwd = input(<span class="hljs-string">&quot;&#x8BF7;&#x8F93;&#x5165;&#x60A8;&#x7684;&#x5BC6;&#x7801;&#xFF1A;&quot;</span>)
            user_pwd2 = input(<span class="hljs-string">&quot;&#x8BF7;&#x518D;&#x6B21;&#x8F93;&#x5165;&#x60A8;&#x7684;&#x5BC6;&#x7801;&#xFF1A;&quot;</span>)
            <span class="hljs-keyword">if</span> user_pwd == user_pwd2:
                print(<span class="hljs-string">&quot;&#x606D;&#x559C;&#x60A8;&#xFF0C;&#x6CE8;&#x518C;&#x6210;&#x529F;&#xFF01;&quot;</span>)
                sql = <span class="hljs-string">&quot;insert into user values(&apos;%s&apos;,&apos;%s&apos;) &quot;</span>
                date = (user_name, user_pwd)
                cur.execute(sql %date)
                connect.commit()
                cur.close()
                connect.close()
                <span class="hljs-keyword">break</span>
            <span class="hljs-keyword">else</span>:
                print(<span class="hljs-string">&quot;&#x60A8;&#x4E24;&#x6B21;&#x8F93;&#x5165;&#x7684;&#x5BC6;&#x7801;&#x4E0D;&#x4E00;&#x6837;&#xFF0C;&#x8BF7;&#x91CD;&#x65B0;&#x8F93;&#x5165;&#xFF01;&quot;</span>)
        <span class="hljs-keyword">break</span>
</code></pre>
<hr>
<ul>
<li><h3 id="&#x767B;&#x5F55;">&#x767B;&#x5F55;</h3>
</li>
</ul>
<pre><code class="lang-py"><span class="hljs-comment"># coding:utf-8</span>
<span class="hljs-keyword">import</span> sys
<span class="hljs-keyword">import</span> pymysql

<span class="hljs-comment"># &#x8FDE;&#x63A5;&#x6570;&#x636E;&#x5E93;</span>
connect = pymysql.connect(
    host=<span class="hljs-string">&quot;localhost&quot;</span>,
    user=<span class="hljs-string">&quot;root&quot;</span>,
    password=<span class="hljs-string">&quot;123456&quot;</span>,
    port=<span class="hljs-number">3306</span>,
    db=<span class="hljs-string">&quot;xdl&quot;</span>,
    charset=<span class="hljs-string">&quot;utf8&quot;</span>,
    )
i = <span class="hljs-number">0</span>
<span class="hljs-comment"># &#x5B9E;&#x4F8B;&#x5316;&#x6E38;&#x6807;</span>
cur = connect.cursor()

<span class="hljs-keyword">while</span> i &lt; <span class="hljs-number">3</span>:
    b = <span class="hljs-number">1</span>
    <span class="hljs-keyword">while</span> b != <span class="hljs-number">0</span>:
        <span class="hljs-comment"># &#x83B7;&#x53D6;&#x7528;&#x6237;&#x540D;</span>
        account_name = input(<span class="hljs-string">&apos;&#x8BF7;&#x8F93;&#x5165;&#x60A8;&#x7684;&#x7528;&#x6237;&#x540D;&#xFF1A;&apos;</span>)
        <span class="hljs-comment"># &#x8BFB;&#x53D6;&#x6570;&#x636E;&#x5E93;&#x4E2D;&#x88AB;&#x9501;&#x5B9A;&#x7528;&#x6237;&#x540D;&#x7684;&#x5217;&#x8868;&#xFF0C;&#x5E76;&#x548C;&#x83B7;&#x53D6;&#x7684;&#x7528;&#x6237;&#x540D;&#x8FDB;&#x884C;&#x6BD4;&#x8F83;&#xFF0C;&#x82E5;&#x5B58;&#x5728;&#x76F8;&#x540C;&#x7684;&#xFF0C;&#x5219;&#x5224;&#x5B9A;&#x8BE5;&#x7528;&#x6237;&#x540D;&#x5DF2;&#x88AB;&#x9501;&#x5B9A;</span>
        cur.execute(<span class="hljs-string">&quot;select * from user_lock&quot;</span>)
        results_lock = cur.fetchall()
        <span class="hljs-comment"># print(results_lock)</span>
        <span class="hljs-keyword">if</span> results_lock == ():
            <span class="hljs-keyword">break</span>
        lock_name = []
        <span class="hljs-keyword">for</span> lock_n <span class="hljs-keyword">in</span> results_lock:
            lock_name.append(lock_n)
            <span class="hljs-comment"># print(lock_name)</span>
        <span class="hljs-comment"># print((account_name,))</span>
        <span class="hljs-keyword">if</span> (account_name,) <span class="hljs-keyword">in</span> lock_name:
            print(<span class="hljs-string">&quot;&#x8BE5;&#x7528;&#x6237;&#x540D;&#x5DF2;&#x88AB;&#x9501;&#x5B9A;&#xFF0C;&#x8BF7;&#x91CD;&#x65B0;&#x8F93;&#x5165;&#xFF01;&quot;</span>)

        <span class="hljs-keyword">else</span>:
            b = <span class="hljs-number">0</span>

    <span class="hljs-comment"># &#x8BFB;&#x53D6;&#x6570;&#x636E;&#x5E93;&#x4E2D;&#x6240;&#x6709;&#x7528;&#x6237;&#x540D;&#x548C;&#x5BC6;&#x7801;</span>
    cur.execute(<span class="hljs-string">&quot;select * from user&quot;</span>)
    results = cur.fetchall()
    <span class="hljs-keyword">for</span> user_n <span class="hljs-keyword">in</span> results:
        <span class="hljs-comment"># &#x8BFB;&#x53D6;&#x6570;&#x636E;&#x5E93;&#x4E2D;&#x6240;&#x6709;&#x7528;&#x6237;&#x540D;</span>
        user_name = user_n[<span class="hljs-number">0</span>]
        <span class="hljs-comment"># &#x8BFB;&#x53D6;&#x6570;&#x636E;&#x5E93;&#x4E2D;&#x6240;&#x6709;&#x7528;&#x6237;&#x540D;&#x5BF9;&#x4E8E;&#x7684;&#x5BC6;&#x7801;</span>
        user_pwd = user_n[<span class="hljs-number">1</span>]
        <span class="hljs-keyword">if</span> user_name == account_name:
            j = <span class="hljs-number">0</span>
            <span class="hljs-keyword">while</span> j &lt; <span class="hljs-number">3</span>:
                <span class="hljs-comment"># &#x83B7;&#x53D6;&#x7528;&#x6237;&#x8F93;&#x5165;&#x7684;&#x7528;&#x6237;&#x540D;&#x76F8;&#x5E94;&#x7684;&#x5BC6;&#x7801;</span>
                account_pwd = str(input(<span class="hljs-string">&apos;&#x8BF7;&#x8F93;&#x5165;&#x60A8;&#x7684;&#x5BC6;&#x7801;&#xFF1A;&apos;</span>))
                <span class="hljs-keyword">if</span> account_pwd == user_pwd:
                    print(<span class="hljs-string">&apos;%s,&#x606D;&#x559C;&#x60A8;&#x767B;&#x9646;&#x6210;&#x529F;&#xFF01;&apos;</span> % account_name)
                    cur.close()
                    connect.close()
                    sys.exit()
                <span class="hljs-keyword">else</span>:
                    <span class="hljs-keyword">if</span> j &lt; <span class="hljs-number">3</span>:
                        print(<span class="hljs-string">&apos;&#x8B66;&#x544A;&#xFF1A;%s &#x8F93;&#x5165;&#x5BC6;&#x7801;&#x9519;&#x8BEF;&#xFF0C;&#x8BF7;&#x91CD;&#x65B0;&#x8F93;&#x5165;&#xFF01;&#x60A8;&#x8FD8;&#x6709; %d &#x6B21;&#x673A;&#x4F1A;&#x3002;&apos;</span> % (account_name,<span class="hljs-number">2</span>-j))
                j += <span class="hljs-number">1</span>
            <span class="hljs-keyword">else</span>:
                sql = <span class="hljs-string">&quot;insert into user_lock value(&apos;%s&apos;)&quot;</span>
                date = account_name
                cur.execute(sql % date)
                connect.commit()
                cur.close()
                connect.close()
                print(<span class="hljs-string">&apos;&#x8B66;&#x544A;&#xFF1A;%s &#x60A8;&#x5DF2;&#x8FBE;&#x5230;&#x6700;&#x5927;&#x767B;&#x9646;&#x6B21;&#x6570;&#xFF0C;&#x8D26;&#x53F7;&#x5C06;&#x88AB;&#x9501;&#x5B9A;&#xFF01;&apos;</span> % account_name)
                sys.exit()
    <span class="hljs-keyword">else</span>:
        print(<span class="hljs-string">&apos;&#x8B66;&#x544A;&#xFF1A;%s &#x4E0D;&#x5B58;&#x5728;&#xFF0C;&#x8BF7;&#x91CD;&#x65B0;&#x8F93;&#x5165;&#xFF01;&apos;</span> % account_name)
</code></pre>
<hr>
<ul>
<li><h3 id="&#x89E3;&#x9501;">&#x89E3;&#x9501;</h3>
</li>
</ul>
<pre><code class="lang-py"><span class="hljs-comment"># coding:utf-8</span>

<span class="hljs-keyword">import</span> sys
<span class="hljs-keyword">import</span> pymysql
<span class="hljs-comment"># &#x8FDE;&#x63A5;&#x6570;&#x636E;&#x5E93;</span>
connect = pymysql.connect(
    host = <span class="hljs-string">&quot;localhost&quot;</span>,
    user = <span class="hljs-string">&quot;root&quot;</span>,
    password = <span class="hljs-string">&quot;123456&quot;</span>,
    port = <span class="hljs-number">3306</span>,
    db = <span class="hljs-string">&quot;xdl&quot;</span>,
    charset = <span class="hljs-string">&quot;utf8&quot;</span>,
)

<span class="hljs-comment"># &#x5B9E;&#x4F8B;&#x5316;&#x6E38;&#x6807;</span>
cur = connect.cursor()

unlock_name = input(<span class="hljs-string">&quot;&#x8BF7;&#x8F93;&#x5165;&#x60A8;&#x60F3;&#x89E3;&#x9501;&#x7684;&#x7528;&#x6237;&#x540D;&#xFF1A;&quot;</span>)

sql = <span class="hljs-string">&quot;select * from user_lock&quot;</span>
cur.execute(sql)
result_lock = cur.fetchall()
<span class="hljs-keyword">for</span> lock_n <span class="hljs-keyword">in</span> result_lock:
    lock_name = lock_n[<span class="hljs-number">0</span>]
    <span class="hljs-keyword">if</span> lock_name == unlock_name:
        sql = <span class="hljs-string">&quot;delete from user_lock where name=&apos;%s&apos;&quot;</span>
        date = (unlock_name)
        cur.execute(sql %date)
        connect.commit()
        cur.close()
        connect.close()
        print(<span class="hljs-string">&quot;&#x606D;&#x559C;&#x60A8;&#xFF0C;&#x7528;&#x6237; %s &#x5DF2;&#x7ECF;&#x6210;&#x529F;&#x89E3;&#x9501;&#xFF01;&quot;</span> %unlock_name)
</code></pre>

                    
                    </section>
                
                
                </div>
            </div>
        </div>

        
        <a href="../../home/12.Python实战项目/3.银行项目.html" class="navigation navigation-prev " aria-label="Previous page: 银行项目"><i class="fa fa-angle-left"></i></a>
        
        
        <a href="../../home/12.Python实战项目/5.双色球.html" class="navigation navigation-next " aria-label="Next page: 双色球"><i class="fa fa-angle-right"></i></a>
        
    </div>
</div>

        
<script src="../../gitbook/app.js"></script>

    
    <script src="../../gitbook/plugins/gitbook-plugin-search/lunr.min.js"></script>
    

    
    <script src="../../gitbook/plugins/gitbook-plugin-search/search.js"></script>
    

    
    <script src="../../gitbook/plugins/gitbook-plugin-sharing/buttons.js"></script>
    

    
    <script src="../../gitbook/plugins/gitbook-plugin-fontsettings/buttons.js"></script>
    

<script>
require(["gitbook"], function(gitbook) {
    var config = {"highlight":{},"search":{"maxIndexSize":1000000},"sharing":{"facebook":true,"twitter":true,"google":false,"weibo":false,"instapaper":false,"vk":false,"all":["facebook","google","twitter","weibo","instapaper"]},"fontsettings":{"theme":"white","family":"sans","size":2}};
    gitbook.start(config);
});
</script>

        
    </body>
    
</html>
